<!DOCTYPE html>

<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">

<title>module RubyXL::CellConvenienceMethods - rubyXL 3.4.35</title>


  <meta name="keywords" content="ruby,module,RubyXL::CellConvenienceMethods">


    <meta name="description" content="Documentation for the RubyXL::CellConvenienceMethods module">





<script type="text/javascript">
  var rdoc_rel_prefix = "../";
  var index_rel_prefix = "../";
</script>

<script src="../js/navigation.js" defer></script>
<script src="../js/search.js" defer></script>
<script src="../js/search_index.js" defer></script>
<script src="../js/searcher.js" defer></script>
<script src="../js/darkfish.js" defer></script>

<link href="../css/fonts.css" rel="stylesheet">
<link href="../css/rdoc.css" rel="stylesheet">



<body id="top" role="document" class="module">
<div id="navigation-toggle" role="button" tabindex="0" aria-label="Toggle sidebar" aria-expanded="true" aria-controls="navigation">
  <span aria-hidden="true">&#9776;</span>
</div>


<nav id="navigation" role="navigation">
  <div id="project-navigation">
    <div id="home-section" role="region" title="Quick navigation" class="nav-section">
  <h2>
    <a href="../index.html" rel="home">Home</a>
  </h2>

  <div id="table-of-contents-navigation">
    <a href="../table_of_contents.html#pages">Pages</a>
    <a href="../table_of_contents.html#classes">Classes</a>
    <a href="../table_of_contents.html#methods">Methods</a>
  </div>
</div>

    <div id="search-section" role="search" class="project-section initially-hidden">
  <form action="#" method="get" accept-charset="utf-8">
    <div id="search-field-wrapper">
      <input id="search-field" role="combobox" aria-label="Search"
             aria-autocomplete="list" aria-controls="search-results"
             type="text" name="search" placeholder="Search (/) for a class, method, ..." spellcheck="false"
             title="Type to search, Up and Down to navigate, Enter to load">
    </div>

    <ul id="search-results" aria-label="Search Results"
        aria-busy="false" aria-expanded="false"
        aria-atomic="false" class="initially-hidden"></ul>
  </form>
</div>

  </div>

  

  

  

  

  

  


  <div class="nav-section">
    <h3>Instance Methods</h3>
    <ul class="link-list" role="directory">

      <li ><a href="#method-i-add_hyperlink">add_hyperlink</a></li>

      <li ><a href="#method-i-add_shared_string">add_shared_string</a></li>

      <li ><a href="#method-i-change_border">change_border</a></li>

      <li ><a href="#method-i-change_border_color">change_border_color</a></li>

      <li ><a href="#method-i-change_contents">change_contents</a></li>

      <li ><a href="#method-i-change_fill">change_fill</a></li>

      <li ><a href="#method-i-change_font_bold">change_font_bold</a></li>

      <li ><a href="#method-i-change_font_color">change_font_color</a></li>

      <li ><a href="#method-i-change_font_italics">change_font_italics</a></li>

      <li ><a href="#method-i-change_font_name">change_font_name</a></li>

      <li ><a href="#method-i-change_font_size">change_font_size</a></li>

      <li ><a href="#method-i-change_font_strikethrough">change_font_strikethrough</a></li>

      <li ><a href="#method-i-change_font_underline">change_font_underline</a></li>

      <li ><a href="#method-i-change_horizontal_alignment">change_horizontal_alignment</a></li>

      <li ><a href="#method-i-change_shrink_to_fit">change_shrink_to_fit</a></li>

      <li ><a href="#method-i-change_text_indent">change_text_indent</a></li>

      <li ><a href="#method-i-change_text_rotation">change_text_rotation</a></li>

      <li ><a href="#method-i-change_text_wrap">change_text_wrap</a></li>

      <li ><a href="#method-i-change_vertical_alignment">change_vertical_alignment</a></li>

      <li ><a href="#method-i-fill_color">fill_color</a></li>

      <li ><a href="#method-i-font_color">font_color</a></li>

      <li ><a href="#method-i-font_name">font_name</a></li>

      <li ><a href="#method-i-font_size">font_size</a></li>

      <li ><a href="#method-i-font_switch">font_switch</a></li>

      <li ><a href="#method-i-get_border">get_border</a></li>

      <li ><a href="#method-i-get_border_color">get_border_color</a></li>

      <li ><a href="#method-i-horizontal_alignment">horizontal_alignment</a></li>

      <li ><a href="#method-i-is_bolded">is_bolded</a></li>

      <li ><a href="#method-i-is_italicized">is_italicized</a></li>

      <li ><a href="#method-i-is_struckthrough">is_struckthrough</a></li>

      <li ><a href="#method-i-is_underlined">is_underlined</a></li>

      <li ><a href="#method-i-remove_formula">remove_formula</a></li>

      <li ><a href="#method-i-set_number_format">set_number_format</a></li>

      <li ><a href="#method-i-text_indent">text_indent</a></li>

      <li ><a href="#method-i-text_rotation">text_rotation</a></li>

      <li ><a href="#method-i-text_wrap">text_wrap</a></li>

      <li ><a href="#method-i-vertical_alignment">vertical_alignment</a></li>

    </ul>
  </div>



  <footer id="validator-badges" role="contentinfo">
  <p><a href="https://validator.w3.org/check/referer">Validate</a></p>
  <p>Generated by <a href="https://ruby.github.io/rdoc/">RDoc</a> 6.15.1.</p>
  <p>Based on <a href="http://deveiate.org/projects/Darkfish-RDoc/">Darkfish</a> by <a href="http://deveiate.org">Michael Granger</a>.</p>
</footer>

</nav>

<main role="main" aria-labelledby="module-RubyXL::CellConvenienceMethods">
  
  
    <ol role="navigation" aria-label="Breadcrumb navigation" class="breadcrumb">
      
      <li>
        
        <a href="../RubyXL.html">RubyXL</a><span>::</span>
        
      </li>
      
      <li>
        
        <span>CellConvenienceMethods</span>
        
      </li>
      
    </ol>
  

  <h1 id="module-RubyXL::CellConvenienceMethods" class="anchor-link module">
    module RubyXL::CellConvenienceMethods
  </h1>

  <section class="description">
    
  </section>


  <section id="5Buntitled-5D" class="documentation-section anchor-link">









     <section id="public-instance-5Buntitled-5D-method-details" class="method-section anchor-link">
       <header>
         <h3>Public Instance Methods</h3>
       </header>


      <div id="method-i-add_hyperlink" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-add_hyperlink" title="Link to this method">
                <span class="method-name">add_hyperlink</span>
                <span class="method-args">(url, tooltip = nil)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="add_hyperlink-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 256</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">add_hyperlink</span>(<span class="ruby-identifier">url</span>, <span class="ruby-identifier">tooltip</span> = <span class="ruby-keyword">nil</span>)
  <span class="ruby-identifier">worksheet</span>.<span class="ruby-identifier">relationship_container</span> <span class="ruby-operator">||=</span> <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">OOXMLRelationshipsFile</span>.<span class="ruby-identifier">new</span>
  <span class="ruby-identifier">relationships</span> = <span class="ruby-identifier">worksheet</span>.<span class="ruby-identifier">relationship_container</span>.<span class="ruby-identifier">relationships</span>
  <span class="ruby-identifier">r_id</span> = <span class="ruby-node">&quot;rId#{relationships.size + 1}&quot;</span>
  <span class="ruby-identifier">relationships</span> <span class="ruby-operator">&lt;&lt;</span> <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">Relationship</span>.<span class="ruby-identifier">new</span>(<span class="ruby-value">:id</span> <span class="ruby-operator">=&gt;</span> <span class="ruby-identifier">r_id</span>, <span class="ruby-value">:target</span> <span class="ruby-operator">=&gt;</span> <span class="ruby-identifier">url</span>, <span class="ruby-value">:target_mode</span> <span class="ruby-operator">=&gt;</span> <span class="ruby-string">&#39;External&#39;</span>,
                                            <span class="ruby-value">:type</span> <span class="ruby-operator">=&gt;</span> <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">HyperlinkRelFile</span><span class="ruby-operator">::</span><span class="ruby-constant">REL_TYPE</span>)

  <span class="ruby-identifier">hyperlink</span> = <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">Hyperlink</span>.<span class="ruby-identifier">new</span>(<span class="ruby-value">:ref</span> <span class="ruby-operator">=&gt;</span> <span class="ruby-keyword">self</span>.<span class="ruby-identifier">r</span>, <span class="ruby-value">:r_id</span> <span class="ruby-operator">=&gt;</span> <span class="ruby-identifier">r_id</span>)
  <span class="ruby-identifier">hyperlink</span>.<span class="ruby-identifier">tooltip</span> = <span class="ruby-identifier">tooltip</span> <span class="ruby-keyword">if</span> <span class="ruby-identifier">tooltip</span>
  <span class="ruby-identifier">worksheet</span>.<span class="ruby-identifier">hyperlinks</span> <span class="ruby-operator">||=</span> <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">Hyperlinks</span>.<span class="ruby-identifier">new</span>
  <span class="ruby-identifier">worksheet</span>.<span class="ruby-identifier">hyperlinks</span> <span class="ruby-operator">&lt;&lt;</span> <span class="ruby-identifier">hyperlink</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-add_shared_string" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-add_shared_string" title="Link to this method">
                <span class="method-name">add_shared_string</span>
                <span class="method-args">(str)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="add_shared_string-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 269</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">add_shared_string</span>(<span class="ruby-identifier">str</span>)
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">datatype</span> = <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">DataType</span><span class="ruby-operator">::</span><span class="ruby-constant">SHARED_STRING</span>
  <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">shared_strings_container</span> <span class="ruby-operator">||=</span> <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">SharedStringsTable</span>.<span class="ruby-identifier">new</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">raw_value</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">shared_strings_container</span>.<span class="ruby-identifier">add</span>(<span class="ruby-identifier">str</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_border" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_border" title="Link to this method">
                <span class="method-name">change_border</span>
                <span class="method-args">(direction, weight)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_border-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 71</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_border</span>(<span class="ruby-identifier">direction</span>, <span class="ruby-identifier">weight</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_border</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>, <span class="ruby-identifier">direction</span>, <span class="ruby-identifier">weight</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_border_color" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_border_color" title="Link to this method">
                <span class="method-name">change_border_color</span>
                <span class="method-args">(direction, color)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_border_color-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 76</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_border_color</span>(<span class="ruby-identifier">direction</span>, <span class="ruby-identifier">color</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-constant">Color</span>.<span class="ruby-identifier">validate_color</span>(<span class="ruby-identifier">color</span>)
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_border_color</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>, <span class="ruby-identifier">direction</span>, <span class="ruby-identifier">color</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_contents" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_contents" title="Link to this method">
                <span class="method-name">change_contents</span>
                <span class="method-args">(data, formula_expression = nil)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_contents-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 3</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_contents</span>(<span class="ruby-identifier">data</span>, <span class="ruby-identifier">formula_expression</span> = <span class="ruby-keyword">nil</span>)
  <span class="ruby-identifier">validate_worksheet</span>

  <span class="ruby-keyword">if</span> <span class="ruby-identifier">formula_expression</span> <span class="ruby-keyword">then</span>
    <span class="ruby-keyword">self</span>.<span class="ruby-identifier">datatype</span> = <span class="ruby-keyword">nil</span>
    <span class="ruby-keyword">self</span>.<span class="ruby-identifier">formula</span> = <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">Formula</span>.<span class="ruby-identifier">new</span>(<span class="ruby-value">:expression</span> <span class="ruby-operator">=&gt;</span> <span class="ruby-identifier">formula_expression</span>)
  <span class="ruby-keyword">else</span>
    <span class="ruby-keyword">self</span>.<span class="ruby-identifier">datatype</span> = <span class="ruby-keyword">case</span> <span class="ruby-identifier">data</span>
                    <span class="ruby-keyword">when</span> <span class="ruby-constant">Date</span>, <span class="ruby-constant">Time</span>, <span class="ruby-constant">Numeric</span> <span class="ruby-keyword">then</span> <span class="ruby-keyword">nil</span>
                    <span class="ruby-keyword">else</span> <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">DataType</span><span class="ruby-operator">::</span><span class="ruby-constant">RAW_STRING</span>
                    <span class="ruby-keyword">end</span>
  <span class="ruby-keyword">end</span>

  <span class="ruby-identifier">data</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">date_to_num</span>(<span class="ruby-identifier">data</span>) <span class="ruby-keyword">if</span> <span class="ruby-identifier">data</span>.<span class="ruby-identifier">is_a?</span>(<span class="ruby-constant">Date</span>) <span class="ruby-operator">||</span> <span class="ruby-identifier">data</span>.<span class="ruby-identifier">is_a?</span>(<span class="ruby-constant">Time</span>)

  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">raw_value</span> = <span class="ruby-identifier">data</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_fill" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_fill" title="Link to this method">
                <span class="method-name">change_fill</span>
                <span class="method-args">(rgb = &#39;ffffff&#39;)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_fill-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 165</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_fill</span>(<span class="ruby-identifier">rgb</span> = <span class="ruby-string">&#39;ffffff&#39;</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-constant">Color</span>.<span class="ruby-identifier">validate_color</span>(<span class="ruby-identifier">rgb</span>)
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_fill</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>, <span class="ruby-identifier">rgb</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          <p>Changes fill color of cell</p>


        </div>





      </div>


      <div id="method-i-change_font_bold" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_font_bold" title="Link to this method">
                <span class="method-name">change_font_bold</span>
                <span class="method-args">(bolded = false)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_font_bold-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 210</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_font_bold</span>(<span class="ruby-identifier">bolded</span> = <span class="ruby-keyword">false</span>)
  <span class="ruby-identifier">validate_worksheet</span>

  <span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
  <span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_bold</span>(<span class="ruby-identifier">bolded</span>)
  <span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          <p>Changes font bold settings of cell</p>


        </div>





      </div>


      <div id="method-i-change_font_color" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_font_color" title="Link to this method">
                <span class="method-name">change_font_color</span>
                <span class="method-args">(font_color = &#39;000000&#39;)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_font_color-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 191</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_font_color</span>(<span class="ruby-identifier">font_color</span> = <span class="ruby-string">&#39;000000&#39;</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-constant">Color</span>.<span class="ruby-identifier">validate_color</span>(<span class="ruby-identifier">font_color</span>)

  <span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
  <span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_rgb_color</span>(<span class="ruby-identifier">font_color</span>)
  <span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          <p>Changes font color of cell</p>


        </div>





      </div>


      <div id="method-i-change_font_italics" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_font_italics" title="Link to this method">
                <span class="method-name">change_font_italics</span>
                <span class="method-args">(italicized = false)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_font_italics-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 201</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_font_italics</span>(<span class="ruby-identifier">italicized</span> = <span class="ruby-keyword">false</span>)
  <span class="ruby-identifier">validate_worksheet</span>

  <span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
  <span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_italic</span>(<span class="ruby-identifier">italicized</span>)
  <span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          <p>Changes font italics settings of cell</p>


        </div>





      </div>


      <div id="method-i-change_font_name" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_font_name" title="Link to this method">
                <span class="method-name">change_font_name</span>
                <span class="method-args">(new_font_name = &#39;Verdana&#39;)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_font_name-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 172</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_font_name</span>(<span class="ruby-identifier">new_font_name</span> = <span class="ruby-string">&#39;Verdana&#39;</span>)
  <span class="ruby-identifier">validate_worksheet</span>

  <span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
  <span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_name</span>(<span class="ruby-identifier">new_font_name</span>)
  <span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          <p>Changes font name of cell</p>


        </div>





      </div>


      <div id="method-i-change_font_size" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_font_size" title="Link to this method">
                <span class="method-name">change_font_size</span>
                <span class="method-args">(font_size = 10)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_font_size-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 181</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_font_size</span>(<span class="ruby-identifier">font_size</span> = <span class="ruby-value">10</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">raise</span> <span class="ruby-string">&#39;Argument must be a number&#39;</span> <span class="ruby-keyword">unless</span> <span class="ruby-identifier">font_size</span>.<span class="ruby-identifier">is_a?</span>(<span class="ruby-constant">Integer</span>) <span class="ruby-operator">||</span> <span class="ruby-identifier">font_size</span>.<span class="ruby-identifier">is_a?</span>(<span class="ruby-constant">Float</span>)

  <span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
  <span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_size</span>(<span class="ruby-identifier">font_size</span>)
  <span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          <p>Changes font size of cell</p>


        </div>





      </div>


      <div id="method-i-change_font_strikethrough" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_font_strikethrough" title="Link to this method">
                <span class="method-name">change_font_strikethrough</span>
                <span class="method-args">(struckthrough = false)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_font_strikethrough-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 227</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_font_strikethrough</span>(<span class="ruby-identifier">struckthrough</span> = <span class="ruby-keyword">false</span>)
  <span class="ruby-identifier">validate_worksheet</span>

  <span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
  <span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_strikethrough</span>(<span class="ruby-identifier">struckthrough</span>)
  <span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_font_underline" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_font_underline" title="Link to this method">
                <span class="method-name">change_font_underline</span>
                <span class="method-args">(underlined = false)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_font_underline-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 219</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_font_underline</span>(<span class="ruby-identifier">underlined</span> = <span class="ruby-keyword">false</span>)
  <span class="ruby-identifier">validate_worksheet</span>

  <span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
  <span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_underline</span>(<span class="ruby-identifier">underlined</span>)
  <span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          <p>Changes font underline settings of cell</p>


        </div>





      </div>


      <div id="method-i-change_horizontal_alignment" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_horizontal_alignment" title="Link to this method">
                <span class="method-name">change_horizontal_alignment</span>
                <span class="method-args">(alignment = &#39;center&#39;)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_horizontal_alignment-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 41</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_horizontal_alignment</span>(<span class="ruby-identifier">alignment</span> = <span class="ruby-string">&#39;center&#39;</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_alignment</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>) { <span class="ruby-operator">|</span><span class="ruby-identifier">a</span><span class="ruby-operator">|</span> <span class="ruby-identifier">a</span>.<span class="ruby-identifier">horizontal</span> = <span class="ruby-identifier">alignment</span> }
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_shrink_to_fit" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_shrink_to_fit" title="Link to this method">
                <span class="method-name">change_shrink_to_fit</span>
                <span class="method-args">(shrink_to_fit = false)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_shrink_to_fit-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 56</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_shrink_to_fit</span>(<span class="ruby-identifier">shrink_to_fit</span> = <span class="ruby-keyword">false</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_alignment</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>) { <span class="ruby-operator">|</span><span class="ruby-identifier">a</span><span class="ruby-operator">|</span> <span class="ruby-identifier">a</span>.<span class="ruby-identifier">shrink_to_fit</span> = <span class="ruby-identifier">shrink_to_fit</span> }
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_text_indent" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_text_indent" title="Link to this method">
                <span class="method-name">change_text_indent</span>
                <span class="method-args">(indent)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_text_indent-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 66</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_text_indent</span>(<span class="ruby-identifier">indent</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_alignment</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>) { <span class="ruby-operator">|</span><span class="ruby-identifier">a</span><span class="ruby-operator">|</span> <span class="ruby-identifier">a</span>.<span class="ruby-identifier">indent</span> = <span class="ruby-identifier">indent</span> }
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_text_rotation" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_text_rotation" title="Link to this method">
                <span class="method-name">change_text_rotation</span>
                <span class="method-args">(rot)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_text_rotation-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 61</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_text_rotation</span>(<span class="ruby-identifier">rot</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_alignment</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>) { <span class="ruby-operator">|</span><span class="ruby-identifier">a</span><span class="ruby-operator">|</span> <span class="ruby-identifier">a</span>.<span class="ruby-identifier">text_rotation</span> = <span class="ruby-identifier">rot</span> }
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_text_wrap" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_text_wrap" title="Link to this method">
                <span class="method-name">change_text_wrap</span>
                <span class="method-args">(wrap = false)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_text_wrap-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 51</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_text_wrap</span>(<span class="ruby-identifier">wrap</span> = <span class="ruby-keyword">false</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_alignment</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>) { <span class="ruby-operator">|</span><span class="ruby-identifier">a</span><span class="ruby-operator">|</span> <span class="ruby-identifier">a</span>.<span class="ruby-identifier">wrap_text</span> = <span class="ruby-identifier">wrap</span> }
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-change_vertical_alignment" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-change_vertical_alignment" title="Link to this method">
                <span class="method-name">change_vertical_alignment</span>
                <span class="method-args">(alignment = &#39;center&#39;)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="change_vertical_alignment-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 46</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">change_vertical_alignment</span>(<span class="ruby-identifier">alignment</span> = <span class="ruby-string">&#39;center&#39;</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_alignment</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>) { <span class="ruby-operator">|</span><span class="ruby-identifier">a</span><span class="ruby-operator">|</span> <span class="ruby-identifier">a</span>.<span class="ruby-identifier">vertical</span> = <span class="ruby-identifier">alignment</span> }
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-fill_color" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-fill_color" title="Link to this method">
                <span class="method-name">fill_color</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="fill_color-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 117</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">fill_color</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">get_fill_color</span>(<span class="ruby-identifier">get_cell_xf</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-font_color" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-font_color" title="Link to this method">
                <span class="method-name">font_color</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="font_color-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 112</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">font_color</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">get_rgb_color</span> <span class="ruby-operator">||</span> <span class="ruby-string">&#39;000000&#39;</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-font_name" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-font_name" title="Link to this method">
                <span class="method-name">font_name</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="font_name-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 102</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">font_name</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">get_name</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-font_size" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-font_size" title="Link to this method">
                <span class="method-name">font_size</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="font_size-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 107</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">font_size</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">get_size</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-font_switch" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-font_switch" title="Link to this method">
                <span class="method-name">font_switch</span>
                <span class="method-args">(change_type, arg)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="font_switch-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 243</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">font_switch</span>(<span class="ruby-identifier">change_type</span>, <span class="ruby-identifier">arg</span>)
  <span class="ruby-keyword">case</span> <span class="ruby-identifier">change_type</span>
  <span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">NAME</span>          <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_name</span>(<span class="ruby-identifier">arg</span>)
  <span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">SIZE</span>          <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_size</span>(<span class="ruby-identifier">arg</span>)
  <span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">COLOR</span>         <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_color</span>(<span class="ruby-identifier">arg</span>)
  <span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">ITALICS</span>       <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_italics</span>(<span class="ruby-identifier">arg</span>)
  <span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">BOLD</span>          <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_bold</span>(<span class="ruby-identifier">arg</span>)
  <span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">UNDERLINE</span>     <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_underline</span>(<span class="ruby-identifier">arg</span>)
  <span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">STRIKETHROUGH</span> <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_strikethrough</span>(<span class="ruby-identifier">arg</span>)
  <span class="ruby-keyword">else</span> <span class="ruby-identifier">raise</span> <span class="ruby-string">&#39;Invalid change_type&#39;</span>
  <span class="ruby-keyword">end</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          <p>Performs correct modification based on what type of change_type is specified</p>


        </div>





      </div>


      <div id="method-i-get_border" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-get_border" title="Link to this method">
                <span class="method-name">get_border</span>
                <span class="method-args">(direction)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="get_border-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 31</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">get_border</span>(<span class="ruby-identifier">direction</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_border</span>.<span class="ruby-identifier">get_edge_style</span>(<span class="ruby-identifier">direction</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-get_border_color" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-get_border_color" title="Link to this method">
                <span class="method-name">get_border_color</span>
                <span class="method-args">(direction)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="get_border_color-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 36</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">get_border_color</span>(<span class="ruby-identifier">direction</span>)
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_border</span>.<span class="ruby-identifier">get_edge_color</span>(<span class="ruby-identifier">direction</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-horizontal_alignment" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-horizontal_alignment" title="Link to this method">
                <span class="method-name">horizontal_alignment</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="horizontal_alignment-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 122</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">horizontal_alignment</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">xf_obj</span> = <span class="ruby-identifier">get_cell_xf</span>
  <span class="ruby-keyword">return</span> <span class="ruby-keyword">nil</span> <span class="ruby-keyword">if</span> <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">nil?</span>
  <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">horizontal</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-is_bolded" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-is_bolded" title="Link to this method">
                <span class="method-name">is_bolded</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="is_bolded-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 87</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">is_bolded</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">is_bold</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-is_italicized" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-is_italicized" title="Link to this method">
                <span class="method-name">is_italicized</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="is_italicized-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 82</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">is_italicized</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">is_italic</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-is_struckthrough" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-is_struckthrough" title="Link to this method">
                <span class="method-name">is_struckthrough</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="is_struckthrough-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 97</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">is_struckthrough</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">is_strikethrough</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-is_underlined" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-is_underlined" title="Link to this method">
                <span class="method-name">is_underlined</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="is_underlined-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 92</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">is_underlined</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">is_underlined</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-remove_formula" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-remove_formula" title="Link to this method">
                <span class="method-name">remove_formula</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="remove_formula-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 21</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">remove_formula</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">formula</span> = <span class="ruby-keyword">nil</span>

  <span class="ruby-identifier">calculation_chain</span> = <span class="ruby-identifier">workbook</span> <span class="ruby-operator">&amp;&amp;</span> <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">calculation_chain</span>
  <span class="ruby-identifier">calculation_cells</span> = <span class="ruby-identifier">calculation_chain</span> <span class="ruby-operator">&amp;&amp;</span> <span class="ruby-identifier">calculation_chain</span>.<span class="ruby-identifier">cells</span>
  <span class="ruby-identifier">calculation_cells</span> <span class="ruby-operator">&amp;&amp;</span> <span class="ruby-identifier">calculation_cells</span>.<span class="ruby-identifier">reject!</span> { <span class="ruby-operator">|</span><span class="ruby-identifier">c</span><span class="ruby-operator">|</span>
    <span class="ruby-identifier">c</span>.<span class="ruby-identifier">ref</span>.<span class="ruby-identifier">col_range</span>.<span class="ruby-identifier">c</span> <span class="ruby-operator">==</span> <span class="ruby-keyword">self</span>.<span class="ruby-identifier">column</span> <span class="ruby-operator">&amp;&amp;</span> <span class="ruby-identifier">c</span>.<span class="ruby-identifier">ref</span>.<span class="ruby-identifier">row_range</span>.<span class="ruby-identifier">begin</span> <span class="ruby-operator">==</span> <span class="ruby-keyword">self</span>.<span class="ruby-identifier">row</span>
  }
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-set_number_format" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-set_number_format" title="Link to this method">
                <span class="method-name">set_number_format</span>
                <span class="method-args">(format_code)</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="set_number_format-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 157</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">set_number_format</span>(<span class="ruby-identifier">format_code</span>)
  <span class="ruby-identifier">new_xf</span> = <span class="ruby-identifier">get_cell_xf</span>.<span class="ruby-identifier">dup</span>
  <span class="ruby-identifier">new_xf</span>.<span class="ruby-identifier">num_fmt_id</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">stylesheet</span>.<span class="ruby-identifier">register_number_format</span>(<span class="ruby-identifier">format_code</span>)
  <span class="ruby-identifier">new_xf</span>.<span class="ruby-identifier">apply_number_format</span> = <span class="ruby-keyword">true</span>
  <span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">register_new_xf</span>(<span class="ruby-identifier">new_xf</span>)
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-text_indent" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-text_indent" title="Link to this method">
                <span class="method-name">text_indent</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="text_indent-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 150</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">text_indent</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">xf_obj</span> = <span class="ruby-identifier">get_cell_xf</span>
  <span class="ruby-keyword">return</span> <span class="ruby-keyword">nil</span> <span class="ruby-keyword">if</span> <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">nil?</span>
  <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">indent</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-text_rotation" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-text_rotation" title="Link to this method">
                <span class="method-name">text_rotation</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="text_rotation-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 143</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">text_rotation</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">xf_obj</span> = <span class="ruby-identifier">get_cell_xf</span>
  <span class="ruby-keyword">return</span> <span class="ruby-keyword">nil</span> <span class="ruby-keyword">if</span> <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">nil?</span>
  <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">text_rotation</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-text_wrap" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-text_wrap" title="Link to this method">
                <span class="method-name">text_wrap</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="text_wrap-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 136</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">text_wrap</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">xf_obj</span> = <span class="ruby-identifier">get_cell_xf</span>
  <span class="ruby-keyword">return</span> <span class="ruby-keyword">nil</span> <span class="ruby-keyword">if</span> <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">nil?</span>
  <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">wrap_text</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


      <div id="method-i-vertical_alignment" class="method-detail anchor-link ">
        <div class="method-header">

            <div class="method-heading">
              <a href="#method-i-vertical_alignment" title="Link to this method">
                <span class="method-name">vertical_alignment</span>
                <span class="method-args">()</span>
              </a>
            </div>

        </div>


          <div class="method-controls">
            <details class="method-source-toggle">
              <summary>Source</summary>
            </details>
          </div>



        <div class="method-description">

          <div class="method-source-code" id="vertical_alignment-source">
            <pre><span class="ruby-comment"># File lib/rubyXL/convenience_methods/cell.rb, line 129</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier ruby-title">vertical_alignment</span>
  <span class="ruby-identifier">validate_worksheet</span>
  <span class="ruby-identifier">xf_obj</span> = <span class="ruby-identifier">get_cell_xf</span>
  <span class="ruby-keyword">return</span> <span class="ruby-keyword">nil</span> <span class="ruby-keyword">if</span> <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">nil?</span>
  <span class="ruby-identifier">xf_obj</span>.<span class="ruby-identifier">alignment</span>.<span class="ruby-identifier">vertical</span>
<span class="ruby-keyword">end</span></pre>
          </div>



          


        </div>





      </div>


    </section>

  </section>

</main>
</body>

